access path
英 [ˈækses pɑːθ]
美 [ˈækses pæθ]
访问路径，存取路径
双语例句
- Therefore, if the optimizer's estimate is accurate, this access path should be a very efficient access path.
因此，如果优化器的估计是准确的，则此访问路径应该是一个非常有效的访问路径。 - This type of access path is referred to as a nested loop join ( NLJOIN) with sort composite.
这种类型的访问路径被称为使用复合排序的嵌套循环联接（NLJOIN）。 - You can obtain the statistics from the table descriptor of the table node in the underlying access path graph.
您可以从基础访问路径图中的表节点的表描述符处获得该统计信息。 - With the appropriate access path, the ORDER BY or GROUP BY requirement can be met without sorting.
使用恰当的访问路径，无需排序即可满足ORDERBY或GROUPBY需求。 - The SQL statement itself also impacts the access path selection.
SQL语句本身也会影响访问路径选择。 - IBM does not publish the actual, in-depth details of how the optimizer determines the best access path, but the optimizer is a cost-based optimizer.
IBM并没有发布优化器如何确定最佳存取路径的真正和深入的详细信息，但优化器是一个基于成本的优化器。 - This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost.
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。 - It does this by performing some work ahead of time, such as determining the database access path.
具体表现就是提前执行一些工作，比如确定数据库访问路径。 - The access path shows that a TBSCAN operation is performed over the table CUST_ORDER_HEADER.
访问路径显示在表CUSTORDERHEADER上执行一个TBSCAN操作。 - An index scan is typically shown in Query Tuner as a group of four nodes in the access path graph.
在访问路径图中，一个索引扫描通常作为一组四个节点显示在QueryTuner上。 - This article described the basic concepts of access paths and how to read an access path graph.
本文描述了访问路径的基本概念以及如何解读访问路径图。 - The access path of the query: How are the tables accessed?
查询的访问路径：如何访问这些表？ - There is no FETCH or table node shown in the access path graph because it is an index-only scan.
因为其是一个唯一索引扫描，所以在访问路径图中不显示FETCH或表节点。 - Access plan describes the access path that the DB2 optimizer has chosen for accessing data for an SQL statement.
访问计划描述访问路径，这些路径是DB2优化器为SQL语句访问数据而选择的。 - For simplicity, this article refers to a particular way of satisfying an SQL statement as the access path.
为简单起见，本文引用了一种满足SQL语句的流行方法作为访问路径。 - In addition, the database can have a better understanding of the state of the data it stores, and thereby can produce a more efficient and dynamic access path to the data.
此外，数据库可以更好地理解它存储的数据的状态，从而可以生成到数据的更有效和动态的存取路径。 - To see the table descriptor, right-click the table node in the access path graph.
为了查看表描述符，请右键单击访问路径图上的表节点。 - Keep in mind that this catalog data is what the optimizer uses to make access path decisions.
请记住，优化器使用编目数据决定访问路径。 - This section illustrates how the Query Tuner query annotation and access path graph can help you analyze access paths and SQL performance.
本部分说明QueryTuner查询注释和访问路径图如何帮助您分析访问路径和SQL性能。 - The rest of this section takes you through the access path graph one more time from the data flow perspective so that you can gain a full understanding of the performance aspect of query execution.
本节的其余部分再一次以数据流的观点向您介绍访问路径图以便您可以在查询执行的性能方面获得充分的理解。 - The description of each operation includes a Query Tuner access path graph that explains its operational semantics.
每一个操作的描述都包括一个解释其操作语义的QueryTuner访问路径图。 - Index design has a critical impact on access path selection.
索引设计对访问路径选择至关重要。 - Assuming this to be the case, the underlying access path is considered optimal with high confidence.
假设这是事实，基础访问路径会被认为具有最佳的高可信度。 - The statistics in the DB2 catalog tables are used to estimate the cost of the access path.
用DB2中的目录表来评估访问路径的成本。 - Visual Explain is a new no-charge function that provides access path and related statics for SQL and XQuery statements.
VisualExplain是一个新的免费功能，为SQL和XQuery语句提供访问路径和相关的统计信息。 - So, any interruption to one of the access path does not affect storage access from the host.
因此，其中一条访问路径的中断不会影响从主机发起的存储访问。 - That simple step could lead to a new access path that might dramatically improve query performance.
这个简单的步骤可能产生新的访问路径，可能显著改进查询性能。 - Soft RI in conjunction with statistics may enable the optimizer to generate a more efficient access path.
SoftRI结合统计数据使得优化器能够生成更有效的访问路径。 - The universal relation model aims at achieving the complete access path independence.
泛关系模型的目的在于获得完全的存取路径独立性。 - Design and Implementation of RBAC Security Model of MAC The universal relation model aims at achieving the complete access path independence.
具有强制存取控制的RBAC安全模型的设计与实现泛关系模型的目的在于获得完全的存取路径独立性。